home *** CD-ROM | disk | FTP | other *** search
Wrap
Declare Sub SetWindowPos Lib "User" (ByVal hWnd As Integer, ByVal hWndInsertAfter As Integer, ByVal x As Integer, ByVal Y As Integer, ByVal cx As Integer, ByVal cy As Integer, ByVal wFlags As Integer) Global Const HWND_TOPMOST = -1 Global Const HWND_NOTOPMOST = -2 Global Const SWP_NOACTIVATE = &H10 Global Const SWP_SHOWWINDOW = &H40 ' Option argument values (CreateDynaset, etc) Global Const DB_DENYWRITE = &H1 Global Const DB_DENYREAD = &H2 Global Const DB_READONLY = &H4 Global Const DB_APPENDONLY = &H8 Global Const DB_INCONSISTENT = &H10 Global Const DB_CONSISTENT = &H20 Global Const DB_SQLPASSTHROUGH = &H40 ' Excel constants Global Const XLDOWN = -4121 Type tItem Name As String Master As String Text As String Data1 As String Data2 As String End Type Global arItems() As tItem Global iItems As Integer Global arMasters() As tItem Global iMasters As Integer Type tStock Name As String Description As String UOM As String Cost As Long Stock As Integer Qty As Integer End Type Global arStock() As tStock Global iStocks As Integer Global TB As String * 1 Global Const GRAY = &HC0C0C0 Global Const WHITE = &HFFFFFF Global Const BLACK = &H0 Global sHold As String Global iStep As Integer Global iSteps As Integer Global iLoadM As Integer Global iLoadI As Integer Global iLoadD As Integer Global snarf%